{
 "cells": [
  {
   "cell_type": "code",
   "id": "initial_id",
   "metadata": {
    "collapsed": true,
    "ExecuteTime": {
     "end_time": "2024-09-06T06:41:56.069054Z",
     "start_time": "2024-09-06T06:41:55.786805Z"
    }
   },
   "source": "import pandas as pd",
   "outputs": [],
   "execution_count": 1
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-09-06T06:41:56.129125Z",
     "start_time": "2024-09-06T06:41:56.076191Z"
    }
   },
   "cell_type": "code",
   "source": [
    "import pymysql\n",
    "con = pymysql.connect(host=\"master\",port=3306,user=\"root\",passwd=\"123456\",db=\"bigdata\")"
   ],
   "id": "85753885877bcf34",
   "outputs": [],
   "execution_count": 2
  },
  {
   "metadata": {},
   "cell_type": "markdown",
   "source": "import pymysql",
   "id": "92c025a896ae18ba"
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-09-06T06:43:32.880926Z",
     "start_time": "2024-09-06T06:43:32.849967Z"
    }
   },
   "cell_type": "code",
   "source": [
    "comments = pd.read_sql(\"select * from jd_comment\",con)\n",
    "print(type(comments))\n",
    "comments"
   ],
   "id": "b933c66dd0fa78fd",
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "              id                                            content  score  \\\n",
       "0    19041988693                                     包装有点简陋，用段时间再追评    3.0   \n",
       "1    19082488750  荣耀碧波微蓝这款手机，外观时尚，屏幕分辨率很高，颜色漂亮，机身很轻，整个机身设计流畅，背面是...    5.0   \n",
       "2    19085880702                                    外观还可以，但是老是检测不到卡    3.0   \n",
       "3    19223374727                                      外形外观可以。屏幕音效可以    3.0   \n",
       "4    19851474640                                      有些卡慢。物流还是挺快的。    3.0   \n",
       "..           ...                                                ...    ...   \n",
       "280  21249594585  性价比超级高的一款手机，价格不高，配置内存也很大，性价比很高的千元机，已经是第二次购买给小孩...    5.0   \n",
       "281  21259419616  货收到了，买好多次了，还会继续购买，值得信赖，好喝不贵，大人小孩都能喝，味道好喝，谁买谁爱喝...    5.0   \n",
       "282  21259606217  手机都是在京东自营购买的，这款荣耀八零还是挺好用的，反应速度挺灵敏的，充电也是超快的。运行速...    5.0   \n",
       "283  21305222524          外形外观好。屏幕音效非常好的。拍照效果效果图好。运行速度很快。。其他特色性价比很高    5.0   \n",
       "284  21316801540  手机买来好久了，一直也没顾上评价，用着还不错，整体来说很满意的，外观满分，内存也大，京东上买...    5.0   \n",
       "\n",
       "    productColor productSize location        referenceTime nickname  \\\n",
       "0           粉映晨辉   8GB+256GB       新疆  2023-04-21 01:56:15    7***9   \n",
       "1           碧波微蓝   8GB+256GB       天津  2023-04-25 00:00:12    阳***涵   \n",
       "2           粉映晨辉  12GB+512GB       广东  2023-03-07 14:17:33    2***2   \n",
       "3           碧波微蓝   8GB+256GB       广东  2023-06-10 22:42:56    j***i   \n",
       "4            墨玉青   8GB+256GB       北京  2023-09-21 19:51:16    S***9   \n",
       "..           ...         ...      ...                  ...      ...   \n",
       "280          墨玉青  12GB+256GB       上海  2024-08-03 09:04:24    j***v   \n",
       "281          墨玉青   8GB+256GB      黑龙江  2024-07-24 11:39:43    j***o   \n",
       "282          墨玉青  12GB+256GB       广东  2024-06-28 11:11:02    O***S   \n",
       "283          亮黑色  12GB+256GB       山西  2024-07-15 21:42:35    大***儿   \n",
       "284          亮黑色  12GB+256GB       山西  2024-07-04 17:53:13    5***7   \n",
       "\n",
       "                                         referenceName  \n",
       "0    荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...  \n",
       "1    荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...  \n",
       "2    荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...  \n",
       "3    荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...  \n",
       "4    荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...  \n",
       "..                                                 ...  \n",
       "280  荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...  \n",
       "281  荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...  \n",
       "282  荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...  \n",
       "283  荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...  \n",
       "284  荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...  \n",
       "\n",
       "[285 rows x 9 columns]"
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>content</th>\n",
       "      <th>score</th>\n",
       "      <th>productColor</th>\n",
       "      <th>productSize</th>\n",
       "      <th>location</th>\n",
       "      <th>referenceTime</th>\n",
       "      <th>nickname</th>\n",
       "      <th>referenceName</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19041988693</td>\n",
       "      <td>包装有点简陋，用段时间再追评</td>\n",
       "      <td>3.0</td>\n",
       "      <td>粉映晨辉</td>\n",
       "      <td>8GB+256GB</td>\n",
       "      <td>新疆</td>\n",
       "      <td>2023-04-21 01:56:15</td>\n",
       "      <td>7***9</td>\n",
       "      <td>荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19082488750</td>\n",
       "      <td>荣耀碧波微蓝这款手机，外观时尚，屏幕分辨率很高，颜色漂亮，机身很轻，整个机身设计流畅，背面是...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>碧波微蓝</td>\n",
       "      <td>8GB+256GB</td>\n",
       "      <td>天津</td>\n",
       "      <td>2023-04-25 00:00:12</td>\n",
       "      <td>阳***涵</td>\n",
       "      <td>荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>19085880702</td>\n",
       "      <td>外观还可以，但是老是检测不到卡</td>\n",
       "      <td>3.0</td>\n",
       "      <td>粉映晨辉</td>\n",
       "      <td>12GB+512GB</td>\n",
       "      <td>广东</td>\n",
       "      <td>2023-03-07 14:17:33</td>\n",
       "      <td>2***2</td>\n",
       "      <td>荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>19223374727</td>\n",
       "      <td>外形外观可以。屏幕音效可以</td>\n",
       "      <td>3.0</td>\n",
       "      <td>碧波微蓝</td>\n",
       "      <td>8GB+256GB</td>\n",
       "      <td>广东</td>\n",
       "      <td>2023-06-10 22:42:56</td>\n",
       "      <td>j***i</td>\n",
       "      <td>荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>19851474640</td>\n",
       "      <td>有些卡慢。物流还是挺快的。</td>\n",
       "      <td>3.0</td>\n",
       "      <td>墨玉青</td>\n",
       "      <td>8GB+256GB</td>\n",
       "      <td>北京</td>\n",
       "      <td>2023-09-21 19:51:16</td>\n",
       "      <td>S***9</td>\n",
       "      <td>荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>21249594585</td>\n",
       "      <td>性价比超级高的一款手机，价格不高，配置内存也很大，性价比很高的千元机，已经是第二次购买给小孩...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>墨玉青</td>\n",
       "      <td>12GB+256GB</td>\n",
       "      <td>上海</td>\n",
       "      <td>2024-08-03 09:04:24</td>\n",
       "      <td>j***v</td>\n",
       "      <td>荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>21259419616</td>\n",
       "      <td>货收到了，买好多次了，还会继续购买，值得信赖，好喝不贵，大人小孩都能喝，味道好喝，谁买谁爱喝...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>墨玉青</td>\n",
       "      <td>8GB+256GB</td>\n",
       "      <td>黑龙江</td>\n",
       "      <td>2024-07-24 11:39:43</td>\n",
       "      <td>j***o</td>\n",
       "      <td>荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>21259606217</td>\n",
       "      <td>手机都是在京东自营购买的，这款荣耀八零还是挺好用的，反应速度挺灵敏的，充电也是超快的。运行速...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>墨玉青</td>\n",
       "      <td>12GB+256GB</td>\n",
       "      <td>广东</td>\n",
       "      <td>2024-06-28 11:11:02</td>\n",
       "      <td>O***S</td>\n",
       "      <td>荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>21305222524</td>\n",
       "      <td>外形外观好。屏幕音效非常好的。拍照效果效果图好。运行速度很快。。其他特色性价比很高</td>\n",
       "      <td>5.0</td>\n",
       "      <td>亮黑色</td>\n",
       "      <td>12GB+256GB</td>\n",
       "      <td>山西</td>\n",
       "      <td>2024-07-15 21:42:35</td>\n",
       "      <td>大***儿</td>\n",
       "      <td>荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>21316801540</td>\n",
       "      <td>手机买来好久了，一直也没顾上评价，用着还不错，整体来说很满意的，外观满分，内存也大，京东上买...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>亮黑色</td>\n",
       "      <td>12GB+256GB</td>\n",
       "      <td>山西</td>\n",
       "      <td>2024-07-04 17:53:13</td>\n",
       "      <td>5***7</td>\n",
       "      <td>荣耀80 1.6亿像素超清主摄 AI Vlog视频大师 全新Magic OS 7.0系统 5...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>285 rows × 9 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 4
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-09-06T06:44:38.416699Z",
     "start_time": "2024-09-06T06:44:38.409718Z"
    }
   },
   "cell_type": "code",
   "source": "comments.groupby(\"location\")[\"location\"].count()",
   "id": "46f351ce2f873b4b",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "location\n",
       "上海      9\n",
       "云南      4\n",
       "内蒙古     2\n",
       "北京     19\n",
       "吉林      2\n",
       "四川     18\n",
       "天津      9\n",
       "宁夏      1\n",
       "安徽      3\n",
       "山东     16\n",
       "山西      7\n",
       "广东     83\n",
       "广西     10\n",
       "新疆      6\n",
       "江苏     19\n",
       "江西      7\n",
       "河北     12\n",
       "河南      8\n",
       "浙江      6\n",
       "海南      2\n",
       "海外      1\n",
       "港澳      1\n",
       "湖北      7\n",
       "湖南      7\n",
       "甘肃      2\n",
       "福建      3\n",
       "贵州      1\n",
       "辽宁      9\n",
       "重庆      6\n",
       "陕西      4\n",
       "黑龙江     1\n",
       "Name: location, dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 7
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-09-06T06:48:20.149461Z",
     "start_time": "2024-09-06T06:47:41.017662Z"
    }
   },
   "cell_type": "code",
   "source": [
    "# 全表读取，加载到python内存中，如果表比较大，容易导致内存溢出\n",
    "cars = pd.read_sql(\"select * from cars\",con)\n",
    "cars"
   ],
   "id": "212dfe12bd4436e2",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "            card    city  county            carid    mid  fx      road  \\\n",
       "0        皖A9A7N2  340500  340522  117988031603010  00001  西南  34052055   \n",
       "1        皖A9A7N2  340500  340522  117988031603010  01001  西南  34052056   \n",
       "2        皖A9A7N2  340500  340522  117985031601010  01214  西南  34052057   \n",
       "3        皖A9A7N2  340500  340522  117984031601010  01024  西北  34052058   \n",
       "4        皖A9A7N2  340500  340522  117970031606010  01022  西北  34052059   \n",
       "...          ...     ...     ...              ...    ...  ..       ...   \n",
       "3371107  皖ARUTA4  340100  340111  117291031748010  00102   南  34172364   \n",
       "3371108  皖ARUTA4  340100  340111  117291031744010  00214   南  34172365   \n",
       "3371109  皖ARUTA4  340100  340111  117291031744010  00024   东  34250757   \n",
       "3371110  皖ARUTA4  340100  340111  117291031744010  01014   东  34250758   \n",
       "3371111  皖ARUTA4  340100  340111  117294031743010  01011   东  34250759   \n",
       "\n",
       "                 ts  speed  \n",
       "0        1614711895  36.38  \n",
       "1        1614711904  35.38  \n",
       "2        1614711914  45.38  \n",
       "3        1614711924  45.29  \n",
       "4        1614712022  75.29  \n",
       "...             ...    ...  \n",
       "3371107  1614818317  31.64  \n",
       "3371108  1614818374  35.64  \n",
       "3371109  1614818430  79.72  \n",
       "3371110  1614818445  53.72  \n",
       "3371111  1614818459  35.72  \n",
       "\n",
       "[3371112 rows x 9 columns]"
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>card</th>\n",
       "      <th>city</th>\n",
       "      <th>county</th>\n",
       "      <th>carid</th>\n",
       "      <th>mid</th>\n",
       "      <th>fx</th>\n",
       "      <th>road</th>\n",
       "      <th>ts</th>\n",
       "      <th>speed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>皖A9A7N2</td>\n",
       "      <td>340500</td>\n",
       "      <td>340522</td>\n",
       "      <td>117988031603010</td>\n",
       "      <td>00001</td>\n",
       "      <td>西南</td>\n",
       "      <td>34052055</td>\n",
       "      <td>1614711895</td>\n",
       "      <td>36.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>皖A9A7N2</td>\n",
       "      <td>340500</td>\n",
       "      <td>340522</td>\n",
       "      <td>117988031603010</td>\n",
       "      <td>01001</td>\n",
       "      <td>西南</td>\n",
       "      <td>34052056</td>\n",
       "      <td>1614711904</td>\n",
       "      <td>35.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>皖A9A7N2</td>\n",
       "      <td>340500</td>\n",
       "      <td>340522</td>\n",
       "      <td>117985031601010</td>\n",
       "      <td>01214</td>\n",
       "      <td>西南</td>\n",
       "      <td>34052057</td>\n",
       "      <td>1614711914</td>\n",
       "      <td>45.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>皖A9A7N2</td>\n",
       "      <td>340500</td>\n",
       "      <td>340522</td>\n",
       "      <td>117984031601010</td>\n",
       "      <td>01024</td>\n",
       "      <td>西北</td>\n",
       "      <td>34052058</td>\n",
       "      <td>1614711924</td>\n",
       "      <td>45.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>皖A9A7N2</td>\n",
       "      <td>340500</td>\n",
       "      <td>340522</td>\n",
       "      <td>117970031606010</td>\n",
       "      <td>01022</td>\n",
       "      <td>西北</td>\n",
       "      <td>34052059</td>\n",
       "      <td>1614712022</td>\n",
       "      <td>75.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3371107</th>\n",
       "      <td>皖ARUTA4</td>\n",
       "      <td>340100</td>\n",
       "      <td>340111</td>\n",
       "      <td>117291031748010</td>\n",
       "      <td>00102</td>\n",
       "      <td>南</td>\n",
       "      <td>34172364</td>\n",
       "      <td>1614818317</td>\n",
       "      <td>31.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3371108</th>\n",
       "      <td>皖ARUTA4</td>\n",
       "      <td>340100</td>\n",
       "      <td>340111</td>\n",
       "      <td>117291031744010</td>\n",
       "      <td>00214</td>\n",
       "      <td>南</td>\n",
       "      <td>34172365</td>\n",
       "      <td>1614818374</td>\n",
       "      <td>35.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3371109</th>\n",
       "      <td>皖ARUTA4</td>\n",
       "      <td>340100</td>\n",
       "      <td>340111</td>\n",
       "      <td>117291031744010</td>\n",
       "      <td>00024</td>\n",
       "      <td>东</td>\n",
       "      <td>34250757</td>\n",
       "      <td>1614818430</td>\n",
       "      <td>79.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3371110</th>\n",
       "      <td>皖ARUTA4</td>\n",
       "      <td>340100</td>\n",
       "      <td>340111</td>\n",
       "      <td>117291031744010</td>\n",
       "      <td>01014</td>\n",
       "      <td>东</td>\n",
       "      <td>34250758</td>\n",
       "      <td>1614818445</td>\n",
       "      <td>53.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3371111</th>\n",
       "      <td>皖ARUTA4</td>\n",
       "      <td>340100</td>\n",
       "      <td>340111</td>\n",
       "      <td>117294031743010</td>\n",
       "      <td>01011</td>\n",
       "      <td>东</td>\n",
       "      <td>34250759</td>\n",
       "      <td>1614818459</td>\n",
       "      <td>35.72</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3371112 rows × 9 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 8
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-09-06T06:50:03.497967Z",
     "start_time": "2024-09-06T06:50:02.979358Z"
    }
   },
   "cell_type": "code",
   "source": "cars.groupby(\"city\")[\"city\"].count()",
   "id": "f724f32b5a029791",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "city\n",
       "340100    3186640\n",
       "340200      21472\n",
       "340300      32880\n",
       "340400      38864\n",
       "340500      21680\n",
       "340600       5520\n",
       "340700      15152\n",
       "340800      48904\n",
       "Name: city, dtype: int64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 12
  },
  {
   "metadata": {},
   "cell_type": "code",
   "outputs": [],
   "execution_count": null,
   "source": "",
   "id": "e67f941139c2e6a4"
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
